UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/bRuJc04mBIL6ND4ui4lwAaEsAbEIWNRBbjtHiBADE='
WHERE
key_id = 'b432fb9e9acad84af8edc0e4cb53779ddabdd310c1b32a7827d8df8d5bd103f7'
AND (
token = 'n/bRuJc04mBIL6ND4ui4lwAaEsAbEIWNRBbjtHiBADE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)