UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VVH8jfJ4DLjkjV2qxV+1vVkDme0B6nvti8WiiPG8o3s='
WHERE
key_id = '9b85b1c666b15fce7ec17b7310458092f33d6237a2408ed1f7929d1221c608a3'
AND (
token = 'VVH8jfJ4DLjkjV2qxV+1vVkDme0B6nvti8WiiPG8o3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)