UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b0FpJd91rDDlgZhgKIdp7H52tZ58EATf6Pgl8ya+Dyk='
WHERE
key_id = '7a47d48932a64af33b498c84c17162ea022abecf8edf4cb22334959deabacf3b'
AND (
token = 'b0FpJd91rDDlgZhgKIdp7H52tZ58EATf6Pgl8ya+Dyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)