UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xqf9Wgos85imEXmiOi3sFiAgm6riVugvGEHW2T/1bq0='
WHERE
key_id = 'b28e2b4ad1edfa61e8f955e1f14c311fe6778829c84bf15e05159bc389c45ae7'
AND (
token = 'Xqf9Wgos85imEXmiOi3sFiAgm6riVugvGEHW2T/1bq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)