UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trAOq2s2wg758QrDUuirjPRJA07edp3vjt7/GD7+Z+8='
WHERE
key_id = 'a76e04acbb4ddfec80200fdac2b8e4d00404e506fe2d6445e32593bae28d41fb'
AND (
token = 'trAOq2s2wg758QrDUuirjPRJA07edp3vjt7/GD7+Z+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)