UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rZgFuNHUsxqgzbk6JtFkByRgZrP23SrlkbXl80vYGVs='
WHERE
key_id = 'c4b1bd323503442889ecf5b7f00a3cfa9cf1bc60302e81b72179e4e00e4b99dd'
AND (
token = 'rZgFuNHUsxqgzbk6JtFkByRgZrP23SrlkbXl80vYGVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)