UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0P2Jcg8Y0rH5rctf8Eg2W996hmmq6fjRAB8rhnbHQB4='
WHERE
key_id = 'fede254839b17117b3c2a7b423da2dbc7bf8769d07f1e593924f34844f896e5b'
AND (
token = '0P2Jcg8Y0rH5rctf8Eg2W996hmmq6fjRAB8rhnbHQB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)