UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V/xBk2p1YqzBYU7NAe9AqbA0GuY6YRcivrUa1BlNCtA='
WHERE
key_id = '8254b1d77bf6681c306a35513265f28686f9d775d02a73395283a83fb7e1d395'
AND (
token = 'V/xBk2p1YqzBYU7NAe9AqbA0GuY6YRcivrUa1BlNCtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)