UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJ9D7F9+neZdljailXF4eIiCQnKKeKV0W0KfSxqnkuA='
WHERE
key_id = 'bb11c4238e52ea2bc1648aac1825cfa01b6e42f19cbf27484a8c5a50b20adec6'
AND (
token = 'xJ9D7F9+neZdljailXF4eIiCQnKKeKV0W0KfSxqnkuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)