UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3tWi8K0rXxWBp8OhcHJN2LObWiSRq6SfDFbaBw74AyM='
WHERE
key_id = '9f9fee70dde296fec0630cbbd08771662afbbd47e43faba5ed9b3ec8a8577478'
AND (
token = '3tWi8K0rXxWBp8OhcHJN2LObWiSRq6SfDFbaBw74AyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)