UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cWuCh2586IE/jWYy9lDBrfGcMvK0Xt6Z30H0UugC4q4='
WHERE
key_id = '0e4238b80d18f75998da2b0563c0dc16dc64a67f22c139e063abe75cf5ea404a'
AND (
token = 'cWuCh2586IE/jWYy9lDBrfGcMvK0Xt6Z30H0UugC4q4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)