UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q3oWapWMXrHON3q2HD/gvBnM86vybrZg9Mt4fQDI+0Y='
WHERE
key_id = '204f5ddd2f05d922f8ec96f7bb8332a7a1299dc0d045ffbaaecc21c2a337fdb5'
AND (
token = 'q3oWapWMXrHON3q2HD/gvBnM86vybrZg9Mt4fQDI+0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)