UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8KrV3pLKOdF8ZNdltLaxJVtA/APAlNOfa1MlsW3fdU='
WHERE
key_id = '2ca1104bf927842294c03ee02804746e01b9098528429c9d9378ef3dbdf23958'
AND (
token = 'p8KrV3pLKOdF8ZNdltLaxJVtA/APAlNOfa1MlsW3fdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)