UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9PDvDDd6MK0tyimN+v1qnf6hgnEORj9e/APAG2mup80='
WHERE
key_id = '781909121419a30c188f8c7b7fbfd030200bf37a6e0ab952fcb16ae3c9381471'
AND (
token = '9PDvDDd6MK0tyimN+v1qnf6hgnEORj9e/APAG2mup80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)