UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxhZ4h/0HbGDu3HPbxhPpgKttW4aPoukIVQzPaNHTxc='
WHERE
key_id = '5b4281ac9bb11bede26a0e186697d84548b8e1c598f85521582e97f725e22df6'
AND (
token = 'TxhZ4h/0HbGDu3HPbxhPpgKttW4aPoukIVQzPaNHTxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)