UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wK8cJOKtP0PpOfLVUAkLZFJV3Eser3O524+U/K18MNg='
WHERE
key_id = 'e1f5faae24f7a0c35114a45d1312c3dcb622cbb659c20d9784cde00fb4178b81'
AND (
token = 'wK8cJOKtP0PpOfLVUAkLZFJV3Eser3O524+U/K18MNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)