UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPNwNBX6lEMIMjtVDlO0RhuNqak3Koi97V/DiaYiWAg='
WHERE
key_id = 'c27d654957790129088d2104207745afd0a5dfc09d891363fa8b728fde08f929'
AND (
token = 'YPNwNBX6lEMIMjtVDlO0RhuNqak3Koi97V/DiaYiWAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)