UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ch2IX0t4kjxXeYNMvNjEsxvi5SrekE/pVE/TxbdYU54='
WHERE
key_id = '46ff64ac35d2bcef07922977304a84f41fd95c93f4773cb82718eec1268e36c2'
AND (
token = 'ch2IX0t4kjxXeYNMvNjEsxvi5SrekE/pVE/TxbdYU54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)