UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dlH5ORmDgkb42r5SubvD12xNP5FJrcSrXVxDTYuVk0='
WHERE
key_id = '552d6a716bdc082f19107a97b7749e8d981227ed66b71c6cc0327a149a6bb2a3'
AND (
token = '7dlH5ORmDgkb42r5SubvD12xNP5FJrcSrXVxDTYuVk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)