UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vUNfehM7mikW5eYfu9w5QwyPozvEamUMFZ9wxaYICVw='
WHERE
key_id = '4bfd2dd8b099844c80467f40b934e25f5cf4e20dc6789f3d66e08fb8035679be'
AND (
token = 'vUNfehM7mikW5eYfu9w5QwyPozvEamUMFZ9wxaYICVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)