UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QppGX+d6MxLs7l5lBhB+Gi9OlSDSmYHuMqDfvTxMMKM='
WHERE
key_id = '596473e9bca3d4b6c224f174aa4041e996d969f4a6d199bb94618baa4e12fb1a'
AND (
token = 'QppGX+d6MxLs7l5lBhB+Gi9OlSDSmYHuMqDfvTxMMKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)