UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+8PTMcoZ3F/WypZ9HLishu69+sbU2OJuMAVxhNoJH2M='
WHERE
key_id = 'd0d461988dd99a8089a7720eb85926ad53540b4521c1afe2b37ae2c7244523c1'
AND (
token = '+8PTMcoZ3F/WypZ9HLishu69+sbU2OJuMAVxhNoJH2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)