UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vI0CR6vG53+tNFRPnIbS2H5q+jcm6J82gwWn12/IkS0='
WHERE
key_id = 'b3ea0220e1e0ea545eb832525efd3295cd53278fcc0918f24bfeea551f790916'
AND (
token = 'vI0CR6vG53+tNFRPnIbS2H5q+jcm6J82gwWn12/IkS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)