UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbPiuS9II4ONVZhPYyVN2SuX6hKJ+SkVVfHf++fA5Us='
WHERE
key_id = '42a527c9254b7f952d456a95ad7a71a83f5c137909c761733fa70fa807859369'
AND (
token = 'hbPiuS9II4ONVZhPYyVN2SuX6hKJ+SkVVfHf++fA5Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)