UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jGmEFDH9fURyXYZhQCUYkEynEDgKG6UnTYlwpSVwAg='
WHERE
key_id = '51fed22628b125b6d5e49f8d15f7b4105745ea78f19a51637b66de0303048a4e'
AND (
token = '9jGmEFDH9fURyXYZhQCUYkEynEDgKG6UnTYlwpSVwAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)