UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HB+H0uQXhcpOrtO0Fww4VG9yv3RuDTP1NuQ8L50g9iU='
WHERE
key_id = '0cc7212631c3a5aa485b78cc598de285b8386cb0606e98705cfe6c53936e7f9a'
AND (
token = 'HB+H0uQXhcpOrtO0Fww4VG9yv3RuDTP1NuQ8L50g9iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)