UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '94T6dF87R8DwbnZPs0vPKdXHV40xTFgYfO3SHjVAV38='
WHERE
key_id = 'c304a8ae2c5725381b656c4d05f11c68c7efffa845f3bffcb8e05e5201da82be'
AND (
token = '94T6dF87R8DwbnZPs0vPKdXHV40xTFgYfO3SHjVAV38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)