UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGnpKmA7PEmYHvz3bNNRJ4+9BIiRv2nTGJItIhYejOQ='
WHERE
key_id = 'bfb505937b305fa427c00dafd53043c6db76ed832b10244c1f7d546409adece3'
AND (
token = 'vGnpKmA7PEmYHvz3bNNRJ4+9BIiRv2nTGJItIhYejOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)