UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bb3UVIO6/yr5doY4iOwDB1WnBo2pTZr/9weITDQp+wI='
WHERE
key_id = 'd289ae3ada797324ca515edada7ecf499a4e6831f306801630176afe427a59cc'
AND (
token = 'Bb3UVIO6/yr5doY4iOwDB1WnBo2pTZr/9weITDQp+wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)