UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vaVAvWz1FrRn9jgft6CXBbyHiMvTMwjdx9YKM3WMPTg='
WHERE
key_id = '59c7213f57bec3781b8e902c4aa8da53924411555104cdd70c4200b8cf40a688'
AND (
token = 'vaVAvWz1FrRn9jgft6CXBbyHiMvTMwjdx9YKM3WMPTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)